﻿
--INSERT TBL_PRODUCTHANDBOOK_CATEGORY
--select 6 as category_id, 'KHÁC' AS CATEGORY_NAME, 'OTHER' AS CATEGORY_NAME_EN, 1 AS CATEGORY_STATUS 

--UPDATE TBL_PRODUCTHANDBOOK_CATEGORY
--SET CATEGORY_NAME = N'TÍN DỤNG'
--WHERE category_id = 1

--DELETE FROM TBL_PRODUCTHANDBOOK_CATEGORY
--WHERE category_id = 6

SELECT * FROM TBL_PRODUCTHANDBOOK_CATEGORY

select * from tbl_producthandbook_product

update [dbo].[TBL_PRODUCT_HANDBOOK_PRODUCT_DETAIL]
set Overview_product_en = Overview_product, Condition_product_en = Condition_product,Document_product_en=Document_product

select * from TBL_Product_Handbook_Product_Detail
select * from [TBL_Product_Handbook_Product_Detail]
select * from server12.SMECustomer360.dbo.TBL_CHECKLIST_SUB_PRODUCT

select * from TBL_CHECKLIST_DOCUMENT


delete from server12.SMECustomer360.[dbo].TBL_Product_Handbook_Product_Detail
insert server12.SMECustomer360.dbo.TBL_Product_Handbook_Product_Detail
select * from TBL_Product_Handbook_Product_Detail

